package com.hydl.power.mapper;

import com.hydl.power.pojo.IncomingCabinet;
import com.hydl.power.pojo.Powerdata;

import java.util.Date;
import java.util.List;

public interface IncomingCabinetMapper {


    int addIncomingCabinet(IncomingCabinet incomingCabinet);

    String getDayPowerDataByRoomId(String roomId);

    String getWeekPowerDataByRoomId(String roomId, Date startTime, Date endTime);

    String getMonthPowerDataByRoomId(String roomId);

    String getSumPowerDataByRoomId(String roomId);

    List<IncomingCabinet> getLoadPtByProjectId(String projectId);

    Double getpPowerFactor(String powerRoomId);

    List<IncomingCabinet> queryIncoming(String time,String deviceId);

    List<IncomingCabinet> queryYesterdayIncoming(String time,String deviceId);

    List<IncomingCabinet> queryByDeviceIdLike(String roomId);

    String getDayPowerDataByProjectId(String projectId);

    String getMonthPowerDataByProjectId(String projectId);

    String getSumPowerDataByProjectId(String projectId);

    int queryTransformerCount(String projectId);

    String queryYearPowerDataByRprojectId(String projectId,String createTime);

    String queryMonthPowerDataByRprojectId(String projectId,String createTime);

    List<IncomingCabinet> queryeTheSameDayPower(String projectId,String strartTime);

    List<IncomingCabinet> queryeEveryDayPower(String projectId,String startTime,String endTime);

    List<IncomingCabinet> queryeTransformerPt(String projectId,String startTime);

    List<IncomingCabinet> queryeLoadAnalysis(String sn,String startTime);

    IncomingCabinet  queryeMaxPt(String sn,String startTime);

    IncomingCabinet  queryeMinPt(String sn,String startTime);


    List<IncomingCabinet> queryeLoadPtf(String sn,String startTime,String endTime);

    IncomingCabinet  queryeMaxPtf(String sn,String startTime,String endTime);

    IncomingCabinet  queryeMinPtf(String sn,String startTime,String endTime);

}
